Interview Questions

1. The technique used to prevent normalization anomalies is called?

Options:

a. Referential integrity constraints

b. Normalization

c. Functional dependencies

Reveal Answer

2. A table in NF should satisfy which of the following options?

Options:

a. The table should have at least one candidate key

b. A column should not have more than one value

c. There can be no duplicate rows

Reveal Answer

3. Which of the following options describe 2NF?

Options:

a. There are no partial dependencies.

b. All non-prime attributes should fully be dependent on one of the candidate keys

c. It deals with foreign keys

Reveal Answer

4. A table in 3NF should satisfy which of the following option?

Options:

a. There are no transitive dependencies

b. All the columns are dependent on the primary key

c. It should be in 2NF

Reveal Answer

5. If a table is in 2NF then all its non key attributes should be dependent on every part of the primary key

Options:

a. true

b. false

Reveal Answer

6. If a table is in 3NF then there should be no non key attribute that is dependent on another non key attribute

Options:

a. true

b. false

Reveal Answer

7. A highly normalized database slows the database performance

Options:

a. true

b. false

Reveal Answer

8. What are the advantages of normalization?

Options:

a. It removes database redundancy

b. It improves storage efficiency

c. It enforces referential integrity

d. It allows for better security control

Reveal Answer

Interview Questions and Answer

1. The technique used to prevent normalization anomalies is called?

2. A table in NF should satisfy which of the following options?

3. Which of the following options describe 2NF?

4. A table in 3NF should satisfy which of the following option?

5. If a table is in 2NF then all its non key attributes should be dependent on every part of the primary key

6. If a table is in 3NF then there should be no non key attribute that is dependent on another non key attribute

7. A highly normalized database slows the database performance

8. What are the advantages of normalization?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources